'''
安装三个包
  pip install pandas openpyxl xlrd
  1.pandas
  2.openpyxl
  3.xlrd
'''
import pandas as pd
import openpyxl
import shutil

if __name__ == '__main__':
    row = 2
    while True:
        wb = openpyxl.load_workbook('无标题_20240926200627.xlsx')
        sheet = wb['无标题_page1']
        cell_value = sheet.cell(row=row, column=7).value
        if cell_value == None :
            break
        print(cell_value)
        shutil.copyfile(f'D:\Desktop\新建文件夹\{cell_value}', f'D:\Desktop\新建文件夹2\{cell_value}')
        row = row +1